﻿CREATE TABLE [dbo].[UserInfo] (
    [UID]      INT           IDENTITY (1, 1) NOT NULL,
    [account]  NVARCHAR (50) NOT NULL,
    [password] NVARCHAR (50) NOT NULL,
    [realname] NVARCHAR (20) NULL,
    [islocked] BIT           CONSTRAINT [DF_UserInfo_islocked] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED ([UID] ASC)
);

